package com.oms.repository.first;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.oms.vo.first.User;

@Repository
public interface UserRepository extends JpaRepository<User, Long> {

	void deleteById(Long id);

	@Query("from User u where u.name=:nm and u.account=:ac")
	List<User> getUsersByNameAndAccount(@Param("nm") String name, @Param("ac") String accunts);
}
